Entity DefinitionLogical Name : RetailStore |
|---|
| Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
|---|---|---|---|---|---|
| RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | |
| OpenDate | The opening date for the RETAIL STORE | DC_OPN_RT_STR | DateCalendar | date | |
| ClosingDate | The closing date for the RETAIL STORE | DC_CL_RT_STR | DateCalendar | date | |
| Size | The size of the RETAIL STORE. This is usually split by the non-sales and sales areas. | QU_SZ_STR | Quantity | DECIMAL(9,3) | |
| SellingAreaSize | The size of the selling floor. in a large STORE this is further split by the sales floor and by the merchandise departments. | QU_SZ_AR_SL | Quantity | DECIMAL(9,3) | |
| LastRemodelDate | Last date this retail store business unit was remodeled. | DC_RMDL_LST | DateCalendar | date |
| Parent Entity | Verb Phrase | Child Entity |
|---|---|---|
| RetailStore | has clients of | RetailStoreCustomer |
| RetailStore | has | StockMeter |
| RetailStore | delineates | MerchandiseHierarchySalesSummary |
| RetailStore | resides in | SupplierPricePromotionZone |
| RetailStore | delineates | POSDepartmentHistory |
| RetailStore | houses | FuelPump |
| RetailStore | has installed | FuelingPoint |
| RetailStore | houses | TankLevelGauge |
| RetailStore | is location for | RetailStoreLocationEvent |
| RetailStore | issues | StoredValueInstrument |
| RetailStore | delineates | RelatedItemAssociationSalesSummary |
| RetailStore | delineates | PromotionalOfferHistory |
| RetailStore | delineates | ItemSalesSummary |
| RetailStore | has | SalesMeter |
| RetailStore | is tracked by | StoreHistory |
| RetailStore | issues | GiftCertificate |
| BusinessUnit | can be a | RetailStore |